Preserving Aggregation in an Object-Relational DBMS
نویسندگان
چکیده
Aggregation is an important concept in database design where composite objects can be modelled during the design of database applications. Therefore, preserving the aggregation concept in database implementation is essential. In this paper, we propose models for implementation of aggregation in an Object-Relational Database Management System (ORDBMS) through the use of index clusters and nested tables. ORDBMS is a commercial Relational Database Management Systems (RDBMS), like Oracle, which support some object-oriented concepts. We will also show how queries can be performed on index clusters and nested tables.
منابع مشابه
XML View Materialization with Deferred Incremental Refresh: the Case of a Restricted Class of Views
A view mechanism can provide a user with an appropriate portion of a database through data filtering and aggregation. Views are often materialized for query performance improvement, and in that case, their consistency needs to be maintained against updates of the underlying data. They can be either recomputed or incrementally refreshed by reflecting only the relevant updates. With the emergence...
متن کاملObject-Relational DBMS
In this paper we present a classification of the applications that require DBMS technology and show where Relational DBMSs, Object-oriented DBMSs and ObjectRelational DBMSs fit. Our purpose is to indicate the kinds of problems each kind of DBMS solves. As will be seen, "one size does not fit all"; i.e. there is no DBMS that solves all the applications we are going to discuss. Then, we indicate ...
متن کاملAn XML Storage System for Object-Oriented/Object-Relational DBMSs
As XML has become popular as a document standard in the World Wide Web, a lot of research has been done on the XML storage systems, which store and manage XML documents using existing DBMSs. Most of the research activities, however, assume a relational DBMS instead of an object-oriented/object-relational (OO/OR) DBMS, which offers more powerful modeling capabilities. In this paper, we present t...
متن کاملManagement of XML Documents in Object-Relational Databases
Many applications deal with complex XML documents that need to be made persistent. We investigate the use of the object-relational modeling approach that combines both the strengths of object oriented concepts and relational DBMS technology provided by current DBMS vendors. As a prerequisite, we analyze the document definition and generate the equivalent object-relational database schema in SQL...
متن کاملEvaluation of object-relational database systems for fulltext retrieval
Object-relational database systems add object-oriented features to relational DBMS and allow the DBMS’s functionality to be extended to new application domains. For the important domain of fulltext retrieval and document management, we analyze whether current object-relational DBMS are already able to compete with specialized information retrieval (IR) systems. After discussing the main require...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2002